This is a SSMS (SQL Server Management Studio) option that use for discard results after execution. When enabled this option will discard results after the execution. The advantage of disabling the option is that it will improve the performance by using less memory, because it not returns string like confirmation message, output etc.
Disable discard option
-- USE DATABASE
USE AVI
--SELECT RECORD FROM TABLE
SELECT * FROM INFO
Screen Shot
Enable discard option
For enabling this option first open new tab of SSMS, then go to Tools >> Options >> Query Results > SQL Server >> Results to Grid >> Discard Results After Execution.
Now execute any query. For demonstration I execute SELECT query.
Note: in both case if we check execution time that are dissimilar when table have heavy data.
Leave Comment